Agenda of the Video▶️: Use Conditional Formatting to highlight information in Excel.<br />-----------------------------------------------------------------------------------------------<br />Learn the steps and the technique. <br />Here, we are updating "Status" and based on this information "Cell" automatically changes their "Text Colour".<br /><br />️Follow the shared Steps: -<br />✍️Select the Entire Table - goto HomeTab - Conditional Formatting - Color Scales - New Rule (New Formatting Rule) - Select a Rule Type - Use a Formula to Determine which Cells to Format - Edit the Rule Description (Format Values where this Formula is True, put the first Condition here) - Select First Text Color, now Repeat the same Step for Applying Multiple but Different "Colour" which takes effect on Changing the Cell Status.<br /><br />Set Rules and apply <br /><br />✅Select the "Cells" that you want to "Conditionally Format".<br /><br />✅On the Home tab, in the Tables group, click Highlight Cell Rules.<br />Select the command you want, such as between, Equal to Text that Contains, or a Date Occurring.<br /><br />✅Enter the values you want to use, and then select a format (fill, text, or border color), and then click OK.<br />---------------------------------------------------------------------------------------------------------------------------
